Based on novels of the same name, The Vampire Diaries captivated audiences with a supernatural love triangle between a teenage girl and two brothers